Tabela Hospital

Definicja tabeli Hospital

Name

Hospital

Code

Hospital

Comment

Tabela szpitali


Lista kolumn tabeli Hospital

Name

Code

HospitalID

HospitalID

HospitalMainBookNoID

HospitalMainBookNoID

Active

Active

StartDT

StartDT

StopDT

StopDT

DeptAdmCode

DeptAdmCode

DeptLocationCode

DeptLocationCode


Kolumna HospitalID tabeli Hospital

Definicja kolumny HospitalID tabeli Hospital

Name

HospitalID

Code

HospitalID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna HospitalMainBookNoID tabeli Hospital

Definicja kolumny HospitalMainBookNoID tabeli Hospital

Name

HospitalMainBookNoID

Code

HospitalMainBookNoID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli Hospital

Definicja kolumny Active tabeli Hospital

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StartDT tabeli Hospital

Definicja kolumny StartDT tabeli Hospital

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Hospital

Definicja kolumny StopDT tabeli Hospital

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna DeptAdmCode tabeli Hospital

Definicja kolumny DeptAdmCode tabeli Hospital

Name

DeptAdmCode

Code

DeptAdmCode

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna DeptLocationCode tabeli Hospital

Definicja kolumny DeptLocationCode tabeli Hospital

Name

DeptLocationCode

Code

DeptLocationCode

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Lista kluczy tabeli Hospital

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Hospital

Definicja klucza Identifier_1 tabeli Hospital

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment